Stored Procedures [dbo].[BAEConfigurationUpdate]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@ConfigurationIDint4
@Variablevarchar(256)256
@CurrentValuevarchar(4096)4096
@DefaultValuevarchar(4096)4096
@Descriptionvarchar(1024)1024
@Categoryvarchar(256)256
SQL Script
create procedure [dbo].[BAEConfigurationUpdate] @ConfigurationID as
int,
    @Variable AS varchar(256),
    @CurrentValue AS varchar(4096),
    @DefaultValue AS varchar(4096),
    @Description AS varchar(1024),
    @Category AS varchar(256)
AS
    UPDATE Configuration
    SET
    Variable =         @Variable,            
    CurrentValue =     @CurrentValue,            
    DefaultValue = @DefaultValue,                
    Description = @Description,            
    Category = @Category            

    WHERE ConfigurationID = @ConfigurationID;

GO
Uses